General Settings for PostgreSQL

The following instruction guides you through the process of creating a new connection. To successfully establish a new connection to local/remote PostgreSQL - no matter via SSH, HTTP or SSL, set the connection properties in the corresponding boxes: Connection name, Host name, Port number, User name, and Password.

By default, PostgreSQL gives "postgres" as username and leave the password field blank.

Connection Name
A friendly name to best describe your connection.

Host Name/IP Address
A host name where the database is situated or the IP address of the server.

Port
A TCP/IP port for connecting to the database server.

Default Database
Set the initial database to which the user connects when making connection.

User Name
User name for connecting to the database server.

Password
Password for connecting to the server.

If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol SSH / HTTP is another solution.

Note: For security reasons native remote direct connections to the PostgreSQL server are disabled. Therefore, you may not be able to use Navicat Premium or other similar PostgreSQL admin applications running on your computer to connect to the remote server. For more details, refer to next paragraph on Server Administration.

For Server Administration:
By default, PostgreSQL only allows connections from the local machine using TCP/IP connections. Other machines will not be able to connect unless you modify listen_addresses in the postgresql.conf file, enable host-based authentication by modifying the $PGDATA/pg_hba.conf file, and restart the server. For more information: Client Authentication

See also:
Advanced Settings

Related topics:
SSH, HTTP